home *** CD-ROM | disk | FTP | other *** search
DB2 Bind | 1993-05-19 | 2.3 KB | 65 lines |
- QELIB NAN1MNJIPIONEER 3
- BEGIN DECLARE SECTION
- END DECLARE SECTION
- DECLARE C1 CURSOR FOR ST1
- PREPARE ST1 FROM :stmt
- OPEN C1
- FETCH C1 INTO :buf
- CLOSE C1
- BEGIN DECLARE SECTION
- END DECLARE SECTION
- DECLARE C2 CURSOR FOR ST2
- PREPARE ST2 FROM :stmt
- OPEN C2
- FETCH C2 INTO :auth
- CLOSE C2
- DECLARE C3 CURSOR FOR ST3
- PREPARE ST3 INTO :temp FROM :stmt
- DESCRIBE ST3 INTO :temp
- DECLARE C4 CURSOR FOR ST4
- CLOSE C4
- EXECUTE ST4 USING DESCRIPTOR :temp
- OPEN C4 USING DESCRIPTOR :temp
- EXECUTE ST4
- OPEN C4
- DECLARE C5 CURSOR FOR ST5
- FETCH C5 USING DESCRIPTOR :temp
- CLOSE C5
- DECLARE C6 CURSOR FOR ST6
- PREPARE ST6 INTO :sqlda FROM :stmt
- OPEN C6
- DECLARE C7 CURSOR FOR ST7
- PREPARE ST7 INTO :sqlda FROM :stmt
- OPEN C7
- DECLARE C8 CURSOR FOR ST8
- PREPARE ST8 INTO :sqlda FROM :stmt
- OPEN C8
- COMMIT
- ROLLBACK
- DECLARE C9 CURSOR FOR ST9
- CLOSE C9
- DECLARE C10 CURSOR FOR ST10
- PREPARE ST10 FROM :stmt
- DECLARE C11 CURSOR FOR ST11
- DECLARE C12 CURSOR FOR ST12
- DECLARE C13 CURSOR FOR ST13
- DECLARE C14 CURSOR FOR ST14
- DECLARE C15 CURSOR FOR ST15
- DECLARE C16 CURSOR FOR ST16
- DECLARE C17 CURSOR FOR ST17
- DECLARE C18 CURSOR FOR ST18
- DECLARE C19 CURSOR FOR ST19
- DECLARE C20 CURSOR FOR ST20
- DECLARE C21 CURSOR FOR ST21
- DECLARE C22 CURSOR FOR ST22
- DECLARE C23 CURSOR FOR ST23
- DECLARE C24 CURSOR FOR ST24
- DECLARE C25 CURSOR FOR ST25
- DECLARE C26 CURSOR FOR ST26
- DECLARE C27 CURSOR FOR ST27
- DECLARE C28 CURSOR FOR ST28
- DECLARE C29 CURSOR FOR ST29
- DECLARE C30 CURSOR FOR ST30
- DECLARE C31 CURSOR FOR ST31
- DECLARE C32 CURSOR FOR ST32
-